Importing ODBC

Setting Up an ODBC Data Source Connection

  1. To setup the connection of the data source, you need to install the corresponding driver.
  2. Then, setup the DSN (Data Source Name) using the ODBC Administrator.

Note: You can consult with the driver provider about how to setup the DSN.



Connecting to ODBC data source in Navicat

  1. Click the Import from button in Paths and Encoding of the Import Wizard. Choose the data source from the Connection drop-down list and provide valid Username and Password.


    Or, type the connection string directly in the Import from text box.


  2. All available tables will be included in the list if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.